Data Stores

In 1Integrate, a data store describes where some external spatial data is being read from or written to.

This represents the data which will be analysed by Rules and Actions within 1Integrate.

The data store can be:

• An Oracle Spatial database with or without workspaces enabled.

• Other data formats via an FME desktop integration (requires an FME desktop license).

  Formats available include file formats (e.g. ESRI shapefile or MapInto TAB file) and database formats (e.g. PostGIS).

• Other data formats available via project-specific bespoke data stores.

When running a session using a data store, the data is stored in the cache (see Session Cache).

Note: Names of classes and properties in 1Integrate can contain any ISO 8859 characters. Unicode is not supported.

Note: All lengths, areas, and co-ordinates used in 1Integrate are in dataset units (the co-ordinate system used in the external data source). 1Integrate does not perform any automatic co-ordinate conversions.

Supported Data Store Types

1Integrate supports the following types of datastores for input and output:

• MapInfo TAB (MFAL)

• Oracle

• PostGIS

• Comma Separated Value (CSV)

• Esri File Geodatabase (FILEGDB)

• Esri Shape

• Bentley Microstation Design (V8)

• Microsoft SQL Server Spatial